let
    Source = CommonDataService.Database("medium-midas-prod.crm11.dynamics.com"),
    dbo_cr713_scanningstats = Source{[Schema="dbo",Item="cr713_scanningstats"]}[Data],
    #"Removed Other Columns" = Table.SelectColumns(dbo_cr713_scanningstats,{"cr713_teamname", "cr713_certificateoforigindate", "cr713_workshift", "cr713_datacategory", "cr713_receiptdate", "cr713_transactionquantity", "cr713_transactionvolume", "cr713_id", "cr713_spcreateddate", "cr713_spmodifieddate", "cr713_appstartdate", "cr713_notifiedmidas", "cr713_submittedcount", "cr713_midasapproveddate"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns",{{"cr713_teamname", "Team"}, {"cr713_workshift", "Shift"}, {"cr713_datacategory", "Data Type"}, {"cr713_receiptdate", "Receipt Date"}, {"cr713_transactionquantity", "Transaction"}, {"cr713_transactionvolume", "Volume"}, {"cr713_spcreateddate", "Created Date"}, {"cr713_spmodifieddate", "Modified Date"}, {"cr713_appstartdate", "App Start Date"}, {"cr713_notifiedmidas", "Notified MIDAS"}, {"cr713_certificateoforigindate", "COO Date"}, {"cr713_submittedcount", "Submitted Count"}, {"cr713_midasapproveddate", "MIDAS Approved Date"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"COO Date", type date}}),
    #"Reordered Columns" = Table.ReorderColumns(#"Changed Type",{"COO Date", "Team", "Shift", "Data Type", "Receipt Date", "Transaction", "Volume", "Created Date", "Modified Date", "App Start Date", "Notified MIDAS"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Reordered Columns",{{"Receipt Date", type date}}),
    #"Reordered Columns1" = Table.ReorderColumns(#"Changed Type1",{"COO Date", "Team", "Shift", "Data Type", "Receipt Date", "Transaction", "Volume", "App Start Date", "Created Date", "Modified Date", "Notified MIDAS"}),
    #"Sorted Rows" = Table.Sort(#"Reordered Columns1",{{"COO Date", Order.Descending}}),
    #"Renamed Columns1" = Table.RenameColumns(#"Sorted Rows",{{"Receipt Date", "Date of Receipt"}}),
    #"Replaced Value" = Table.ReplaceValue(#"Renamed Columns1","Receipts","Received",Replacer.ReplaceText,{"Data Type"})
in
    #"Replaced Value"